﻿SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME FROM %dbname%.INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_BODY = 'EXTERNAL'
AND ROUTINE_TYPE = 'PROCEDURE'